03. Video: Introduction to JOINs
Your First JOIN
This entire lesson will be focused on JOINs. The whole purpose of JOIN statements is to allow us to pull data from more than one table at a time.
Again - JOINs are useful for allowing us to pull data from multiple tables. This is both simple and powerful all at the same time.
With the addition of the JOIN statement to our toolkit, we will also be adding the ON statement.
We use ON clause to specify a JOIN condition which is a logical statement to combine the table in FROM and JOIN statements.